/*     */ package com.qmsk.business.member.memberdepositbill.dao;
/*     */ 
/*     */ import com.qmsk.business.sys.basic.SupportDAO;
/*     */ import com.utils.basic.MapUtils;
/*     */ import com.utils.gson.in.GsonHeadManyRows;
/*     */ import com.utils.gson.in.GsonHeadOneRow;
/*     */ import com.utils.gson.out.GsonEbRst;
/*     */ import java.sql.SQLException;
/*     */ import java.util.HashMap;
/*     */ import java.util.Map;
/*     */ 
/*     */ public class MemberDepositBillDAO extends SupportDAO
/*     */ {
/*     */   public GsonEbRst getGsonOfShopId(Integer shopId, Integer nPageIdx, Short nPageSize)
/*     */     throws SQLException
/*     */   {
/*  37 */     Object[] params = { shopId };
/*  38 */     return getGsonOfParams("selectSqlOfShopId", "selectCountSqlOfShopId", 
/*  39 */       "selectJsonOfShopId", params, nPageIdx, nPageSize);
/*     */   }
/*     */ 
/*     */   public String getMaxBillNo(Object shopId) throws SQLException {
/*  43 */     return getSpTableFieldDayNoShopId("BillNo", shopId);
/*     */   }
/*     */ 
/*     */   public GsonHeadManyRows getListOfMemberIds(String[] ids) throws SQLException
/*     */   {
/*  48 */     Map params = new HashMap();
/*  49 */     params.put("ids", ids);
/*  50 */     return getManyRowsOfParams("selectSqlOfBillIds", 
/*  51 */       "selectJsonOfBillIds", params);
/*     */   }
/*     */ 
/*     */   public int updateDeposiBill(Object id) throws SQLException {
/*  55 */     Object[] params = { id };
/*  56 */     return update("updateDeposiBill", params);
/*     */   }
/*     */ 
/*     */   public int insertBsBillDpst(Double deposit, Long memberId, String billNo, Long shopId, String createName, String attnName, String memo, int paid)
/*     */     throws SQLException
/*     */   {
/*  62 */     Object[] params = { memberId, shopId, billNo, deposit, 
/*  63 */       createName, attnName, memo, Integer.valueOf(paid) };
/*  64 */     return update("insertBsBillDpst", params);
/*     */   }
/*     */ 
/*     */   public int updateCheckStatus(String userName, String billNo) throws SQLException
/*     */   {
/*  69 */     Object[] params = { userName, billNo };
/*  70 */     return update("updateCheckStatus", params);
/*     */   }
/*     */ 
/*     */   public GsonHeadOneRow getRefundSingle(Object bissId) throws SQLException {
/*  74 */     Object[] params = { bissId };
/*  75 */     return getOneRowOfParams("selectSqlRefundSingle", 
/*  76 */       "selectJsonRefundSingle", params);
/*     */   }
/*     */ 
/*     */   public GsonHeadOneRow getDepositOfId(Long id) throws SQLException {
/*  80 */     Object[] params = { id };
/*  81 */     return getOneRowOfParams("selectSqlDepositOfId", params);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfMemberId(String shopId, Long memberId, Integer nPageIdx, Short nPageSize) throws SQLException
/*     */   {
/*  86 */     Map params = new HashMap();
/*  87 */     MapUtils.addToMap(params, "shopId", shopId);
/*  88 */     MapUtils.addToMap(params, "memberId", memberId);
/*  89 */     return getGsonOfParams("selectSqlOfMemberId", params, nPageIdx, 
/*  90 */       nPageSize, true);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfMemberId1(Map<String, Object> params, Integer nPageIdx, Short nPageSize) throws SQLException
/*     */   {
/*  95 */     return getGsonOfParams("getSqlOfMemberId", params, nPageIdx, 
/*  96 */       nPageSize, true);
/*     */   }
/*     */ 
/*     */   public Long getBussBillOfBussId(Object id) throws SQLException {
/* 100 */     Object[] params = { id };
/* 101 */     return queryForLong("selectBillNo", params, Long.valueOf(0L));
/*     */   }
/*     */ 
/*     */   public int updateBillPaid(Long id) throws SQLException {
/* 105 */     Object[] params = { id };
/* 106 */     return update("updateBillPaid", params);
/*     */   }
/*     */ 
/*     */   public GsonEbRst getGsonOfAll(Map<String, Object> params, Integer nPageIdx, Short nPageSize) throws SQLException
/*     */   {
/* 111 */     return getGsonOfParams("selectSqlOfMemberId", params, nPageIdx, 
/* 112 */       nPageSize, true);
/*     */   }
/*     */ 
/*     */   public int updateGotDepositOfid(Double nDeposit, Long id) throws SQLException {
/* 116 */     Object[] params = { nDeposit, id };
/* 117 */     return update("updateGotDepositOfid", params);
/*     */   }
/*     */ }

/* Location:           C:\Users\Administrator\Desktop\新建文件夹\WEB-INF\classes\
 * Qualified Name:     com.qmsk.business.member.memberdepositbill.dao.MemberDepositBillDAO
 * JD-Core Version:    0.5.3
 */